"Thorsten Froehlich" <tho### [at] trfde>
> > 2. In the list of countris in community section number of povers in each
> > country could be displayed directly with name of country instead of on embeded
> > page to decrease number of generated pages. Sorting according to number of
> > povers in country could be possible.
>
> I know.  We are using mySQL as database, and unfortunately it doe not
> support subselects.  Performing a separate request via the script for each
> country would add too much load, so until mySQL finally gains subselect
> capability or I manage to invent another quick way of collecting these
> statistics (I have a few workarounds like updating the numbers only once per
> day) there won't be any.

select
  country_id,
  count(country_id) as nr
from pov_world_users
order by nr
group by country_id;

??

Post a reply to this message